<?xml version="1.0" encoding="utf-8" ?> 

<!-- Description         :  The description/title of the stored procedure
      RestrictedTo        :  Will only show as an option to the corresponding users
                                "9" - Available to everyone
      StoredProcedureName :  The name of the stored procedure 
      UseXSLTFile        :  true/false - If true a file with the same name needs to exist in the folder with extension xslt.
     
      
      Notes  1. Passing userId - To pass the user id logged in the application to the stored procedure 
                                         create a parameter of userId in the stored procedure.  You do not have 
                                       to specify that in the criteria list. 
      -->
<report Description="PCRO Executed Agreements Summary Report" LongDescription="Lists all corporate-sponsored clinical research agreements executed within a specified time period (i.e., 3 months, YTD, annual); distributed quarterly to MGH/BWH/PHS VPs and department chiefs and ad hoc upon request by senior leadership." RestrictedTo="3145728" StoredProcedureName="" ReportingServicesReportName="PCROExecutedAgreementsSummaryReport" UseXSLTFile="false">
     
     <!-- Enter one or multiple textcriteria nodes.  One for each parameter that the stored procedure expects
      ParameterName :  The name of the stored proc parameter.  
      Description   :  The description to be displayed to the user.
      Type          :  The type of input expected
                          "text" - For free form text
                          "date" - Date value
                           "phone" - Phone number in the format xxx-xxx-xxxx
                           "zipCode" - US zip code
                           "email" - Email
                           "integernumber" - Integer number
                           "decimalnumber" - Decimal number
      IsRequired    :  true/false - If an input is required for this parameter  
      DefaultValue  :  Default value         
      IsVisible     :  true/false to ask the user for input      
     <textcriteria Description="Employee Id" ParameterName="EmployeeID" Type="integernumber" IsRequired="true" DefaultValue="" IsVisible="false"  />-->
     <!-- <textcriteria Description="StartDate" ParameterName="StartDate" IsVisible="true" IsRequired="true" type="date"/>-->
   

     <!-- Enter one or multiple dropdowncriteria nodes.  One for each parameter that the stored procedure expects
      ParameterName :  The name of the stored proc parameter that corresponds to the dropdown.  
      Description   :  The description to be displayed to the user next to the dropdown.
      PopulateFrom  :  The stored procedure name that populates this dropdown.
      ValueColumn   :  The name of the column that should be used as the value column.
      TextColumn    :  The name of the column that should be used as the text column.
      IsRequired    :  true/false - If an input is required  
      DefaultValue  :  The id to be selected by default - Leave blank for no selection

     <dropdowncriteria Description="Company Id" ParameterName="companyId" PopulateFrom="oRetrieveCompanies" ValueColumn="CompanyId" TextColumn="CompanyName" IsRequired="true" DefaultValue="1"  />
-->

     <textcriteria Description="DomainUserId" ParameterName="DomainUserId" IsVisible="false" IsRequired="false" Type="text"/>
     <textcriteria Description="PCRO Executed Date (From)" ParameterName="StartDate" IsVisible="true" IsRequired="true" Type="date"/>
     <textcriteria Description="PCRO Executed Date (To)" ParameterName="EndDate" IsVisible="true" IsRequired="true" Type="date"/>
     <dropdowncriteria Description="Institution" ParameterName="Institution" PopulateFrom="GetInstitutions" PopulateFromStaticParamValues="IgnoreSecurity=Y" ValueColumn="InstitutionId" TextColumn="Description" IsRequired="true" DisplayAllChoice="true"/>
     <listboxcriteria Height="100" SelectionMode="Multi" Description="Department" ParameterName="Department" PopulateFrom="GetDepartments" ValueColumn="DeptId" TextColumn="DepartmentChiefCode" IsRequired="false" DisplayAllChoice="true" DependsOnControlParameterName="Institution" DefaultValue=""/>
     <listboxcriteria Height="100" SelectionMode="Multi" Description="Unit" ParameterName="Unit" PopulateFrom="GetUnits" ValueColumn="UnitId" TextColumn="Unit" IsRequired="false" DisplayAllChoice="true" DependsOnControlParameterName="Department" DefaultValue="0"  />
     <listboxcriteria Height="100" SelectionMode="Multi" Description="PCRO Case Manager" ParameterName="CSCRCaseManager" PopulateFrom="GetCSCRCaseManagers" ValueColumn="PersonId" TextColumn="ManagerName" IsRequired="false" DisplayAllChoice="true" DefaultValue="0"  />
     <dropdowncriteria Description="Including DFCI?" ParameterName="IncludeDanaFarber" PopulateFrom="GetStaticValues" PopulateFromStaticParamValues="Key=YesNoOnly" ValueColumn="StaticDescription" TextColumn="StaticDescription" IsRequired="false" DisplayAllChoice="false" DefaultValue="No"  />
     <dropdowncriteria Description="Show FolderNumber?" ParameterName="ShowFolderNumber" PopulateFrom="GetStaticValues" PopulateFromStaticParamValues="Key=YesNoOnly" ValueColumn="StaticDescription" TextColumn="StaticDescription" IsRequired="false" DisplayAllChoice="false" DefaultValue="No"  />
     <textcriteria Description="Hidden Field to Run FY 08 version of report" IsVisible="false" ParameterName="FY08Figures" IsRequired="false" DisplayAllChoice="false" DefaultValue="Yes"  />
     
</report>

